Bahwan Cybertek 2nd round ques-

Apart from What is what type,

1. Major difference between cursor and ref cursor

2. I have 2 seperate table with only one column.. 1 table is empty having varchar datatype.2nd table also varchar datatype and only having numbers in that column. is it possible to change datatype for both if so , how

3. I have 1 table-
Table1
id	name
EN	England
JP	Japan
CH	China
US	America
NZ	New Zeland
BA	Bangladesh

I want to display US id & name 1st, then BA then rest of the details can be in any order.

4. I have 3 table.

t1 - a column
t2 - b column
t3 - a and b column

t1 and t2 having sum common and uncommon records.
I need a plsql block to update t3 table if t1 and t2 records are same then update t3 with a and b values.

5. What server do u use If cloud then which cloud u r using

6. I have 2 table. t1 having 100 records and t2 having 50 records. both the table having common 10 records.

if inner join - how many rows will be returned
if right outer- t1(+)=t2 how many rows will be returned
if left outer- t1=t2(+) how many rows will be returned
if cross join - how many rows will be returned

7. No of triggers possible in a table

8. How many primary key can be in a table